23. 练习：WHERE

问题

编写一个查询

  1. 从 orders 表提取出 gloss_amt_usd 大于或等于 1000 美元的前五行数据（包含所有列）。

  2. 从 orders 表提取出 total_amt_usd 小于 500 美元的前十行数据（包含所有列）。

Workspace

This section contains either a workspace (it can be a Jupyter Notebook workspace or an online code editor work space, etc.) and it cannot be automatically downloaded to be generated here. Please access the classroom with your account and manually download the workspace to your local machine. Note that for some courses, Udacity upload the workspace files onto https://github.com/udacity , so you may be able to download them there.

Workspace Information:

  • Default file path:
  • Workspace type: sql-evaluator
  • Opened files (when workspace is loaded): n/a

Next Concept